Calculation Property

Returns or sets an XlCalculation constant specifying the calculation mode. Read/write.

XlCalculation can be one of these XlCalculation constants.

xlCalculationAutomatic Formulas are calculated automatically when precedent cells are changed.

xlCalculationManual Formulas are not recalculated until the user initiates a recalculation.

expression.Calculation

expression Required. An expression that returns a Spreadsheet object.

Example

This example places Spreadsheet1 into manual calculation mode.

Sub ManualCalculationMode()

   Dim ssConstants

   Set ssConstants = Spreadsheet1.Constants

   ' Set Spreadsheet1 to manual calculation mode.
   Spreadsheet1.Calculation = ssConstants.xlCalculationManual

End Sub